package com.yipao.db.domain.order;

import lombok.Data;
import lombok.EqualsAndHashCode;

import java.math.BigDecimal;
import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.Arrays;

/**
 * 订单
 *
 * @author tianhao
 */
@Data
@EqualsAndHashCode(callSuper = false)
public class YipaoOrder {
    private Integer id;

    private Integer userId;

    /**
     * 设备id
     */
    private String devId;

    private String orderSn;

    /**
     * 订单状态
     */
    private Short orderStatus;

    /**
     * 支付状态
     */
    private Short payStatus;

    private Short aftersaleStatus;

    private String mobile;

    private String address;

    private String message;

    private BigDecimal goodsPrice;

    private BigDecimal couponPrice;

    private BigDecimal integralPrice;

    private BigDecimal grouponPrice;

    private BigDecimal orderPrice;

    private BigDecimal payAmount;

    private String payId;

    private LocalDateTime payTime;

    private String shipSn;

    private String shipChannel;

    private LocalDateTime shipTime;

    private BigDecimal refundAmount;

    private String refundType;

    private String refundContent;

    private LocalDateTime refundTime;

    private LocalDateTime confirmTime;

    private Short comments;

    private LocalDateTime endTime;

    private LocalDateTime addTime;

    private LocalDateTime updateTime;

    private Boolean deleted;

    /**
     * 已删除
     */
    public static final Boolean IS_DELETED = Deleted.IS_DELETED.value();
    /**
     * 未删除
     */
    public static final Boolean NOT_DELETED = Deleted.NOT_DELETED.value();


    public enum Deleted {
        NOT_DELETED(new Boolean("0"), "未删除"),
        IS_DELETED(new Boolean("1"), "已删除");

        private final Boolean value;

        private final String name;


        Deleted(Boolean value, String name) {
            this.value = value;
            this.name = name;
        }


        public Boolean getValue() {
            return this.value;
        }


        public Boolean value() {
            return this.value;
        }


        public String getName() {
            return this.name;
        }
    }

    public enum Column {
        id("id", "id", "INTEGER", false),
        userId("user_id", "userId", "INTEGER", false),
        orderSn("order_sn", "orderSn", "VARCHAR", false),
        orderStatus("order_status", "orderStatus", "SMALLINT", false),
        aftersaleStatus("aftersale_status", "aftersaleStatus", "SMALLINT", false),
        mobile("mobile", "mobile", "VARCHAR", false),
        address("address", "address", "VARCHAR", false),
        message("message", "message", "VARCHAR", false),
        goodsPrice("goods_price", "goodsPrice", "DECIMAL", false),
        couponPrice("coupon_price", "couponPrice", "DECIMAL", false),
        integralPrice("integral_price", "integralPrice", "DECIMAL", false),
        grouponPrice("groupon_price", "grouponPrice", "DECIMAL", false),
        orderPrice("order_price", "orderPrice", "DECIMAL", false),
        payAmount("pay_amount", "payAmount", "DECIMAL", false),
        payId("pay_id", "payId", "VARCHAR", false),
        payTime("pay_time", "payTime", "TIMESTAMP", false),
        shipSn("ship_sn", "shipSn", "VARCHAR", false),
        shipChannel("ship_channel", "shipChannel", "VARCHAR", false),
        shipTime("ship_time", "shipTime", "TIMESTAMP", false),
        refundAmount("refund_amount", "refundAmount", "DECIMAL", false),
        refundType("refund_type", "refundType", "VARCHAR", false),
        refundContent("refund_content", "refundContent", "VARCHAR", false),
        refundTime("refund_time", "refundTime", "TIMESTAMP", false),
        confirmTime("confirm_time", "confirmTime", "TIMESTAMP", false),
        comments("comments", "comments", "SMALLINT", false),
        endTime("end_time", "endTime", "TIMESTAMP", false),
        addTime("add_time", "addTime", "TIMESTAMP", false),
        updateTime("update_time", "updateTime", "TIMESTAMP", false),
        deleted("deleted", "deleted", "BIT", false);

        private static final String BEGINNING_DELIMITER = "`";

        private static final String ENDING_DELIMITER = "`";

        private final String column;

        private final boolean isColumnNameDelimited;

        private final String javaProperty;

        private final String jdbcType;


        public String value() {
            return this.column;
        }


        public String getValue() {
            return this.column;
        }


        public String getJavaProperty() {
            return this.javaProperty;
        }


        public String getJdbcType() {
            return this.jdbcType;
        }


        Column(String column, String javaProperty, String jdbcType, boolean isColumnNameDelimited) {
            this.column = column;
            this.javaProperty = javaProperty;
            this.jdbcType = jdbcType;
            this.isColumnNameDelimited = isColumnNameDelimited;
        }


        public String desc() {
            return this.getEscapedColumnName() + " DESC";
        }


        public String asc() {
            return this.getEscapedColumnName() + " ASC";
        }


        public static Column[] excludes(Column... excludes) {
            ArrayList<Column> columns = new ArrayList<>(Arrays.asList(Column.values()));
            if (excludes != null && excludes.length > 0) {
                columns.removeAll(new ArrayList<>(Arrays.asList(excludes)));
            }
            return columns.toArray(new Column[]{});
        }


        public String getEscapedColumnName() {
            if (this.isColumnNameDelimited) {
                return new StringBuilder().append(BEGINNING_DELIMITER).append(this.column).append(ENDING_DELIMITER).toString();
            } else {
                return this.column;
            }
        }


        public String getAliasedEscapedColumnName() {
            return this.getEscapedColumnName();
        }
    }
}
